﻿using Abp.UI;
using AngleSharp;
using Camc.Quality.Dto.TableDto;
using Camc.Quality.RecordTable.FormBase;
using Camc.Quality.RecordTable.FormClass;
using Camc.Quality.RecordTable.FormEntity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;

namespace Camc.Quality.Quality.TransformHtml
{
    public static class TableToData
    {

        /// <summary>
        /// base记录表,解析赋值
        /// </summary>
        /// <param name="processId"></param>
        /// <param name="SourceId"></param>
        /// <param name="tableHtml"></param>
        /// <param name="stepId"></param>
        /// <returns></returns>
        public static List<TableBaseDto> ConvertToBaseRecord(Guid processId, string sourceId, string tableHtml, Guid stepId, int sort)
        {
            var context = BrowsingContext.New();

            var document = context.OpenAsync(req => req.Content(tableHtml)).Result;

            var blueListItemsLinq = document.All.Where(m => m.LocalName == "tr");

            List<TableBaseDto> tableBaseDtoList = new List<TableBaseDto>();
            var rowIndex = 0;
            List<string> tableColumnNameList = new List<string>();
            var tableNames = "";
            foreach (var row in blueListItemsLinq)
            {
                if (rowIndex >= 0)
                {
                    if (rowIndex == 0)
                    {
                        //表名
                        tableNames = Removestriphtml(row.QuerySelectorAll("td").FirstOrDefault().TextContent).Trim();
                        rowIndex++;
                        continue;
                    }
                    if (rowIndex == 1)
                    {
                        //表头
                        var tableColumnNames = row.QuerySelectorAll("td");
                        foreach (var tableColumnName in tableColumnNames)
                        {
                            tableColumnNameList.Add(Removestriphtml(tableColumnName.TextContent).Trim());
                        }
                        rowIndex++;
                        continue;
                    }
                    var columns = row.QuerySelectorAll("td");
                    var tableBaseDto = new TableBaseDto();
                    tableBaseDto.Id = Guid.NewGuid();
                    tableBaseDto.ProcessesEntityId = processId;
                    tableBaseDto.WorkStepEntityId = stepId;
                    tableBaseDto.Sort = sort;
                    var colsort = 0;
                    foreach (var column in columns)
                    {
                        switch (tableNames)
                        {
                            //10
                            case "具有证明书的主要零件记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件编号":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "合格证号编号":
                                        tableBaseDto.Certificate = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "通用多媒体记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "部位":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "拍照(摄像)":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "照片（影像）编号":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "确认结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "力矩记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "零件1":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件2":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求_拧紧值N.m":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺要求_拧紧值N.m":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值N.m":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "通用力矩复校记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "零件1":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件2":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "复测力矩N.m":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺力矩N.m":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "恢复力矩N.m":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "力矩扳手编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "通用记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "确认结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "通用总装数据记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺要求":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "舱口盖开闭记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "壳段名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "舱口盖位置或象限":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "打开/关闭":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测力矩":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用力矩扳手编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "胶液配比情况记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "胶液名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录元素":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实际情况":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "进箱舱登记表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "型号":
                                        tableBaseDto.Model = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工作事项":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "进箱时间":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "进箱携带物品":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "携带物品数量":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "出箱确认":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "互检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "质量控制记录表"://待确认
                                switch (tableColumnNameList[colsort])
                                {
                                    case "项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        tableBaseDto.SerialNum = rowIndex - 1;
                                        colsort++;
                                        break;
                                    case "五检":
                                        tableBaseDto.IsInspect = true;
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;

                            //15
                            case "舱口盖开闭测试记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所属部段":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "舱口盖名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否能正常开关":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "产品接地状态检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "接地状态":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品端搭接电阻(mΩ)":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "等电位端搭接电阻(mΩ)":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    case "所用仪器编号":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "强制检验点记录表"://待确认
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测结果":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否合格":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "照片编号":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "五检"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "自动关闭口盖检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "口盖位置":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "部段图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "口盖名称":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查确认项":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否合格":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "伺服机构工艺拉杆长度记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "要求长度（mm）":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测长度（mm）":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "状态检查表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "确认项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "确认结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "部门":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "确认者"://待修改
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "问题记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品状态":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "问题记录":
                                        tableBaseDto.AbnormalRecord = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "解决措施":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNoStart = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "爆索尺寸测量记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "总长（mm）":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "扁平（mm）":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "宽度（mm）":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用仪器编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "整流罩星箭分离弹簧压缩数据记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所属部段":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "弹簧自由长度H0（mm）":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "弹簧的工作载荷P2（N）":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压缩后长度L要求":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压缩后弹簧总长（mm）":
                                        tableBaseDto.FourthMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "载荷支架组合体形位数据记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "单位":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测量值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "设计签署总装数据记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺要求":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "管路活门气密点检查记录表皂泡法":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "系统名称":
                                        tableBaseDto.ParentProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测点前管路图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测点后管路图号":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查压力(MPa)":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查方法":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求值Pa*m3/s":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺要求值":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "管路活门气密点检查记录表氦质谱法":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "系统名称":
                                        tableBaseDto.ParentProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测点前管路图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测点后管路图号":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查压力(MPa)":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查方法":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求值Pa*m3/s":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺要求值":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查点输出Pa•m3/s":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查点漏率Pa•m3/s":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "比对漏孔漏率Pa•m3/s":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "比对装置输出Pa•m3/s":
                                        tableBaseDto.FourthMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "大气本体Pa•m3/s":
                                        tableBaseDto.AtmPressure = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "除了打保险防松外的总装直属件记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "零件1":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件2":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装位置":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "紧固件材料及规格":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "拧紧力矩要求（N·m）":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实际力矩施加值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "防松方式":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "传感器安装测试记录情况统计记录表"://修改
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.ParentProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "状态":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "导通检查点":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试仪器1":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "导通要求阻值":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测阻值1":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "绝缘检查点":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试仪器2"://修改
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "绝缘要求阻值":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测阻值2"://修改
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用指针三用表编号":
                                        tableBaseDto.SecondToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用温湿度计编号":
                                        tableBaseDto.ThirdToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "插头状态检查表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所属仪器/支架":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品状态":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查状态":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNoStart = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;

                            ///仪器电缆安装 8
                            case "惯组安装记录表一":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录点":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "间隙值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "导电胶带层数":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用赛尺编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "惯组安装记录表二":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录要求":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用赛尺编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "电缆剥线试验记录表低频":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "导线编号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "剥线长度1精确到0.5mm":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    //case "剥线长度2精确到0.5mm":
                                    //	tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                    //	colsort++;
                                    //	break;
                                    case "检查导线绝缘层切除后的外观情况":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    //case "检查导线绝缘层切除后的外观情况2":
                                    //	tableBaseDto.SecondConfirmResult = Removestriphtml(column.TextContent);
                                    //	colsort++;
                                    //	break;
                                    case "多媒体（两端皆要拍照）":

                                        tableBaseDto.PhotoNoStart = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    //case "多媒体（两端皆要拍照）2":
                                    //	tableBaseDto.SecondPhotoNo = Removestriphtml(column.TextContent);
                                    //	colsort++;
                                    //	break;
                                    case "测量工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "剥线钳编号":
                                        tableBaseDto.SecondToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "压接实验测量记录表低频":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录要求":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "电缆剥线试验记录表高频":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "输出接口点号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNoStart = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "剥线钳编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测量工具编号":
                                        tableBaseDto.SecondToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "仪器接收检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所属仪器（支架）代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "插头（座）代号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "外观检查":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "电连接器检查":
                                        tableBaseDto.SecondConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "合格证检查":
                                        tableBaseDto.ThirdConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件编号":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "电缆接收检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "电缆代号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "整体外观良好、证件齐全":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "插头（座）正常、代号一致、插针无歪斜":
                                        tableBaseDto.SecondConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "减振垫检查":
                                        tableBaseDto.ThirdConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "电缆高度测量记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "电缆束位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "中间框位置（自前端面）":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "电缆高度（靠I象限）":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            ///装配后工作+总体装配工作 5
                            case "箭地接口保护件检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "安装位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "堵盖规格/图号":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.ThirdConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "通用检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "项目":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "对接面形位记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所属部段":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "整流罩锉修记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "锉修过的安装孔记录":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "整流罩安装后检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "检查项目":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "确认结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "问题记录":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            ///导管接受检查安装记录  17
                            case "导管检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "问题记录":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "缺陷照片":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "管路上箭前吹除记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "吹除压力/Mpa":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "吹除时间/min":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "吹除确认":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "绸布照片":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "气封管流量测试记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "入口压力":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "气源":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "正向流量测量值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "正向流量校准值":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "反向流量测量值":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "反向流量校准值":
                                        tableBaseDto.FourthMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "阀门气瓶过滤器流量计输送管金属软管等检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查状态":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "缺陷照片":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "波纹管变形记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "波纹管":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所属管路":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "管路编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "装配初始压缩量方向":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "允许值":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装前":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装后":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "变形量":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "单机安装位置记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "阀门/过滤器":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "阀门编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "安装距离记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实际安装测量值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "小导管卡箍间距测量表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "管路图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "距离/mm":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNoStart = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "未按要求施加力矩及未打保险防松记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "紧固件材料及规格":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "拧紧力矩要求N.m":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实际力矩施加情况":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "未按要求施加力矩原因/防松方式":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "分解重装记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "时间":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "原因":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "部位":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "更换或返修情况":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "配合七零三绝热记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "绝热部位":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "位置":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否完成":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "绝热去除记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所在部位":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "局部去除要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实际去除情况照片":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "连续拧紧环节力矩复校记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "零件1":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺值1N.m":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "复校值1N.m":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件2":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺值2N.m":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "复校值2N.m":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "零件3":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "管路垫块安装情况记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "管路图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "卡箍位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "垫块安装情况":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "螺钉规格":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "箭体结构防水记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所属部段":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "仪器代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "操作要求":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "确认结果":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "搭接线安装部位防水记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "位置":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录对象":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "操作要求":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否封堵":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "电缆插头防水防热记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "电缆/仪器代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "插头代号":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实施情况":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            //称重类 8
                            case "总装零件称重记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "单件质量(g)":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "总质量（g）":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设备编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "总装耗材称重记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "技术条件":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "领取重量(g)":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "剩余重量(g)":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "丢弃重量(g)":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "上箭重量(g)":
                                        tableBaseDto.FourthMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "箭体称重记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所属部段":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "出厂/飞行状态":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "箭体称重时多装少装产品记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否多装":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "质量（Kg）":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "飞行质量质心设备调平数据记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器读数参考值":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器读数实际值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "飞行质量质心皮重及参数记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录元素":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "横向质心测量记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "后支点称重":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "后支点有效":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "前支点称重":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "前支点有效":
                                        tableBaseDto.FourthMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "大部段称重记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "称重项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "重量（Kg）":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            //极性检查 2
                            case "产品安装确认表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "检查项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查情况":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "阀门安装状态确认表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "确认项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实际状态":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            //接收检查 6
                            case "通用接收检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "记录要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查结果":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNoStart = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "通用保护件检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "颜色":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "安装位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查情况":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "问题记录":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "接口检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查情况":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "问题记录":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNoStart = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "象限标识检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查情况":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "干燥剂检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "记录项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "干燥剂颜色":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "随大部段交付产品明细表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "数量":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否正常":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            //气密 7
                            case "气瓶组充放气速率记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "开始时间":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "结束时间":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "时间要求值":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "结束实测值":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "速率":
                                        tableBaseDto.FourthMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "系统保压记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "检查部位":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "检查状态":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压力要求值（MPa）":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压力实测值（MPa）":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压降要求值（MPa）":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压降实测值（MPa）":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "气瓶压力测试记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "气瓶名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求值":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "阀门使用次数记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "名称/代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "允许使用次数":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "试验项目":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "动作次数":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "阀门测试记录表一":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称/代号":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试状态":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "气封流量测试记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "检测位置":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "要求流量（g/s）":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测量值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "校准后（m3/h）":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "阀门测试记录表二":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称/代号":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测试状态":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "第一次":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "第二次":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            ////
                            /// 10
                            case "电磁阀尾罩检查表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "图号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "箭上位置":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "尾罩是否松动":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "传感器变换器对应关系确认记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "电缆束1":
                                        tableBaseDto.ParentProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "变换器插头座":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "变换器代号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "变换器编号":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "电缆束2":
                                        tableBaseDto.ParentProductName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器插头座":
                                        tableBaseDto.SecondDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器代号":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器编号":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "是否对应":
                                        tableBaseDto.FirstConfirmResult = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "产品安装数量记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "使用数量":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "电连接器插接记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "所属仪器代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "插头座代号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "插接照片":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "防松照片":
                                        tableBaseDto.SecondPhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "防水照片":
                                        tableBaseDto.ThirdPhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "防热照片":
                                        tableBaseDto.FourthPhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "四检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "液位传感器尺寸协调记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "测量项目":
                                        tableBaseDto.RecordElement = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "理论值(mm)":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值(mm)":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "误差(mm)":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "温度":
                                        tableBaseDto.Temperature = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "湿度":
                                        tableBaseDto.Humidity = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "密封插头压接多媒体记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.ParentProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "传感器代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "箱内低温密封插头压接点":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "输出接口点号":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "插接照片":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "四检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "岗位分工表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "岗位分工":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工作地点":
                                        tableBaseDto.MeasuredActual = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "四检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "低频压接实验测量记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "中间接头型":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "拉脱力检查":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值1":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压接电阻检查":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值2":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "抗电强度检查":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值3":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压接钳编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "微欧计编号":
                                        tableBaseDto.SecondToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "高阻表编号":
                                        tableBaseDto.ThirdToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "测力计编号":
                                        tableBaseDto.RecordItem = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "高频压接点电阻及抗电强度检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "编号":
                                        tableBaseDto.RecordLocation = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "外导体压接电阻要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值1(mΩ)":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "内导体压接电阻要求":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值2":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "内导体抗电强度检查":
                                        tableBaseDto.RecordMainopoint = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值3(mΩ)":
                                        tableBaseDto.ThirdMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "压接钳编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "微欧计编号":
                                        tableBaseDto.SecondToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "高阻表编号":
                                        tableBaseDto.ThirdToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "高频压接点抗拉强度检查记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "外导体拉脱要求":
                                        tableBaseDto.RecordRequire = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值1(mΩ)":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "内导体拉脱力要求":
                                        tableBaseDto.RecordStatus = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值2":
                                        tableBaseDto.SecondMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "拉脱力测试仪编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            //新6表
                            case "电连接器插接多媒体记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "产品型号/代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.ParamCode = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "插接照片":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "防松照片":
                                        tableBaseDto.SecondPhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "防水照片":
                                        tableBaseDto.ThirdPhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "防热照片":
                                        tableBaseDto.FourthPhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "仪器安装电缆余量多媒体记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "产品型号/代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.ParamCode = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "仪器安装分离钢索多媒体记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "产品型号/代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.ParamCode = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "仪器安装分离力测试多媒体记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "产品型号/代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.ParamCode = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "仪器安装力矩记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "产品型号/代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.ParamCode = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "设计要求_拧紧值N.m":
                                        tableBaseDto.DesignerDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "工艺要求_拧紧值N.m":
                                        tableBaseDto.ProcessorDemand = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "备注":
                                        tableBaseDto.Remarks = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值N.m":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "所用工具编号":
                                        tableBaseDto.ToolUsed = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;
                            case "仪器插座安装多媒体记录表":
                                switch (tableColumnNameList[colsort])
                                {
                                    case "序号":
                                        //程序赋值
                                        tableBaseDto.SerialNum = rowIndex - 1; //int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                        colsort++;
                                        break;
                                    case "产品型号/代号":
                                        tableBaseDto.FisrtDrawingNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "名称":
                                        tableBaseDto.FirstDrawingName = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "产品编号":
                                        tableBaseDto.ProductNum = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "参数代号":
                                        tableBaseDto.ParamCode = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "实测值":
                                        tableBaseDto.FirstMeasuredValues = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "多媒体":
                                        tableBaseDto.PhotoNo = Removestriphtml(column.TextContent);
                                        colsort++;
                                        break;
                                    case "三检":
                                        tableBaseDto.IsInspect = false;
                                        if (Removestriphtml(column.TextContent) == "是")
                                        {
                                            tableBaseDto.IsInspect = true;
                                        }
                                        colsort++;
                                        break;
                                    default:
                                        break;
                                }
                                break;


                            default:
                                throw new UserFriendlyException("不能存在" + tableNames);
                        }

                    }
                    tableBaseDtoList.Add(tableBaseDto);

                }
                rowIndex++;
            }
            return tableBaseDtoList;
        }

        /// <summary>
        /// 装入件表
        /// </summary>
        /// <param name="processId">工序</param>
        /// <param name="SourceId">自身Id</param>
        /// <param name="tableHtml"></param>
        /// <param name="stepId">工步</param>
        /// <returns></returns>
        public static List<LoadPieceDto> ConvertToLoadPiece(Guid processId, string SourceId, string tableHtml, Guid stepId, int sort)
        {
            var context = BrowsingContext.New();

            var document = context.OpenAsync(req => req.Content(tableHtml)).Result;

            var blueListItemsLinq = document.All.Where(m => m.LocalName == "tr");
            List<LoadPieceDto> loadPieceDtoList = new List<LoadPieceDto>();
            var rowIndex = 0;
            foreach (var row in blueListItemsLinq)
            {
                var colsort = 1;
                if (rowIndex > 1)
                {
                    var columns = row.QuerySelectorAll("td");
                    var loadPieceDto = new LoadPieceDto();
                    loadPieceDto.Id = Guid.NewGuid();
                    loadPieceDto.WorkStepEntityId = stepId;
                    loadPieceDto.Sort = sort;
                    loadPieceDto.Index = rowIndex - 1;
                    foreach (var column in columns)
                    {
                        switch (colsort)
                        {
                            case 1:
                                loadPieceDto.Code = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 2:
                                loadPieceDto.Name = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 3:
                                loadPieceDto.Number = int.Parse(Removestriphtml(column.TextContent) == "" ? "0" : Removestriphtml(column.TextContent));
                                colsort++;
                                break;
                            case 4:
                                loadPieceDto.Remark = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            default:
                                break;
                        }
                    }
                    loadPieceDtoList.Add(loadPieceDto);
                }
                rowIndex++;
            }
            return loadPieceDtoList;
        }

        /// <summary>
        /// 制造资源
        /// </summary>
        /// <param name="processId">工序</param>
        /// <param name="SourceId">自身Id</param>
        /// <param name="tableHtml"></param>
        /// <param name="stepId">工步</param>
        /// <returns></returns>
        public static List<MakeResourcesDto> ConvertToZZResources(Guid processId, string SourceId, string tableHtml, Guid stepId, int sort)
        {
            var context = BrowsingContext.New();

            var document = context.OpenAsync(req => req.Content(tableHtml)).Result;

            var blueListItemsLinq = document.All.Where(m => m.LocalName == "tr");
            List<MakeResourcesDto> makeResourcesDtoList = new List<MakeResourcesDto>();
            var rowIndex = 0;
            foreach (var row in blueListItemsLinq)
            {
                var colsort = 1;
                if (rowIndex > 1)
                {
                    var columns = row.QuerySelectorAll("td");
                    var makeResourcesDto = new MakeResourcesDto();
                    makeResourcesDto.Id = Guid.NewGuid();
                    makeResourcesDto.WorkStepEntityId = stepId;
                    makeResourcesDto.Sort = sort;
                    makeResourcesDto.Index = rowIndex - 1;
                    foreach (var column in columns)
                    {
                        switch (colsort)
                        {
                            case 1:
                                makeResourcesDto.Type = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 2:
                                makeResourcesDto.ErpId = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 3:
                                makeResourcesDto.SpecsCode = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 4:
                                makeResourcesDto.Name = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 5:
                                makeResourcesDto.Remark = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 6:
                                makeResourcesDto.IdentifyType = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 7:
                                makeResourcesDto.StandardNumber = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 8:
                                makeResourcesDto.IsRequired = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            default:
                                break;
                        }
                    }
                    makeResourcesDtoList.Add(makeResourcesDto);
                }
                rowIndex++;
            }
            return makeResourcesDtoList;
        }
        /// <summary>
        /// 视频表
        /// </summary>
        /// <param name="processId">工序</param>
        /// <param name="SourceId">自身Id</param>
        /// <param name="tableHtml"></param>
        /// <param name="stepId">工步</param>
        /// <returns></returns>
        public static List<VideoDto> ConvertToVideo(Guid processId, string SourceId, string tableHtml, Guid stepId, int sort)
        {
            var context = BrowsingContext.New();

            var document = context.OpenAsync(req => req.Content(tableHtml)).Result;

            var blueListItemsLinq = document.All.Where(m => m.LocalName == "tr");
            List<VideoDto> videoDtoList = new List<VideoDto>();
            var rowIndex = 0;
            foreach (var row in blueListItemsLinq)
            {
                var colsort = 1;
                if (rowIndex > 1)
                {
                    var columns = row.QuerySelectorAll("td");
                    var videoDto = new VideoDto();
                    videoDto.Id = Guid.NewGuid();
                    videoDto.WorkStepEntityId = stepId;
                    videoDto.Sort = sort;
                    videoDto.Index = rowIndex - 1;
                    foreach (var column in columns)
                    {
                        switch (colsort)
                        {
                            case 1:
                                videoDto.VideoFile = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            case 2:
                                videoDto.FileName = Removestriphtml(column.TextContent);
                                colsort++;
                                break;
                            default:
                                break;
                        }
                    }
                    videoDtoList.Add(videoDto);
                }
                rowIndex++;
            }
            return videoDtoList;
        }

        /// <summary>
        /// 工步表
        /// </summary>
        /// <param name="processId"></param>
        /// <param name="SourceId"></param>
        /// <param name="tableHtml"></param>
        /// <param name="stepId"></param>
        /// <returns></returns>
        public static WorkStepEntity ConvertToWorkStep(Guid processId, string SourceId, string tableHtml, Guid stepId)
        {
            var context = BrowsingContext.New();

            var document = context.OpenAsync(req => req.Content(tableHtml)).Result;

            var blueListItemsLinq = document.All.Where(m => m.LocalName == "tr");
            WorkStepEntity multiMediaList = new WorkStepEntity();

            return multiMediaList;
        }
        public static string Removestriphtml(string strhtml)
        {
            string stroutput = strhtml.Trim().Replace("/\n", "");
            Regex regex = new Regex(@"<[^>]+>|</[^>]+>");

            if (strhtml != null)
            {
                stroutput = regex.Replace(stroutput, "");
                return strhtml.Trim();
            }
            return "";
        }
    }
}
